WIP/AR Summary
The WIP/AR Summary report summarizes the unbilled WIP and unapplied progress for each client. This report helps you determine the clients that you need to bill, and includes the date when each client was last billed.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is WIP/AR Summary. In Practice Advantage, the comparable reports are WIP Summary Aging and AR Summary Aging.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Select to Include Transactions Using… |
List |
Determines the date type to use for the date range on the report. The options are transaction date and accounting period date. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Date |
<= |
Today |
Optional Filters | ||
---|---|---|
Available Fields | ||
AR Balance |
Client Name |
Manager |
Business Code |
Client Office |
Primary Partner |
Client |
Client Primary Service Type |
Progress Bills |
Client – Principal |
Client Region |
Return Group |
Client Bill Manager |
Client Sub ID |
Tax Type |
Client Billing Group |
Client Type |
WIP Available |
Client Business Unit |
Date |
WIP Remaining |
Client ID |
Financial Reporting Client Group |
|
Client ID.Sub ID |
Line of Business |
|
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client ID.Sub ID |
Financial Reporting Client Group |
Client |
Client Name |
Line of Business |
Client – Principal |
Client Office |
Manager |
Client Bill Manager |
Client Primary Service Type |
Primary Partner |
Client Billing Group |
Client Region |
Return Group |
Client Business Unit |
Client Sub ID |
Sort Name |
Client ID |
Client Type |
Tax Type |
Sorting | |
---|---|
Available Fields | |
Client ID |
Client Name |
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client ID |
The client ID and sub-ID in Client ID.Sub-ID format. |
Client Name |
The client name. |
WIP Available |
The WIP available for billing. |
Progress Bills |
The total of unapplied progress bills. |
WIP Remaining |
The total amount of WIP available - Progress Bill amount. |
AR Balance |
The total AR balance for the client. |
Last Invoice |
The date of the last invoice for the client. |
WIP/AR Summary Sample Report